﻿CREATE ROLE [ESBPortal]
    AUTHORIZATION [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_update_uddi_admin] TO [ESBPortal]
    AS [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_get_uddi_admin] TO [ESBPortal]
    AS [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_Delete_Request] TO [ESBPortal]
    AS [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_get_pending_request] TO [ESBPortal]
    AS [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_get_pending_request_by_name] TO [ESBPortal]
    AS [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_get_pending_requests] TO [ESBPortal]
    AS [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_get_request_history] TO [ESBPortal]
    AS [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_update_pending_request] TO [ESBPortal]
    AS [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_update_pending_status] TO [ESBPortal]
    AS [dbo];
GO

GRANT EXECUTE
    ON OBJECT::[dbo].[usp_update_pending_status_by_name] TO [ESBPortal]
    AS [dbo];
GO
